import  os,xlrd,arcpy,arcgisscripting,sys,DegreeConvert,xlwt

excelPath = 'C:\Users\lenovo\Desktop\\africa\\data\\coor.xlsx'
excelFile=xlrd.open_workbook(excelPath)
sheet=excelFile.sheet_by_index(0)

gp = arcgisscripting.create()
gp.OverwriteOutput = 1

outputShpPath = sys.argv[1]
outWorkspace = os.path.split(outputShpPath)[0]
shpName = os.path.split(outputShpPath)[-1]

spat_ref = "4326"
gp.CreateFeatureClass_management(outWorkspace, shpName, "POINT", "", "", "", spat_ref)
cur = gp.InsertCursor(outputShpPath,["SHAPE@XY"])
for i in range(0,sheet.nrows):
    arcpy.AddMessage('row:{0}'.format(i))
    row = sheet.row_values(i)
    for j in range(0,sheet.ncols):
        if not row[j]:
            break
        data = row[j].split(';')
        y = DegreeConvert.getRadians(data[0])
        x = DegreeConvert.getRadians(data[1])
        xy = (x, y)
        cur.insertRow([xy])

del cur

